Suspended Tables
When a table is suspended, information about the table including the reason for its suspension is recorded in the attrep_suspended_tables table. If a table is suspended and then unsuspended while the task is running, the entries for that table will be deleted from the attrep_suspended_tables table.
When a task with suspended tables stops, records for that task will remain in the attrep_suspended_tables table. In the event that the tables are still suspended when the task is restarted, the data is deleted and then recorded again.
| Column | Type | Description |
|---|---|---|
|
SERVER_NAME |
nvchar |
The name of the machine on which Replicate is installed. |
|
TASK_NAME |
nvchar |
The name of the Replicate task. |
|
TABLE_OWNER |
nvchar |
The owner of the suspended table. |
|
TABLE_NAME |
nvchar |
The name of the suspended table. |
|
SUSPEND_REASON |
varchar |
The reason why the table was suspended. |
|
SUSPEND_TIMESTAMP |
timestamp |
The date and time the table was suspended. |